/* ***********************************************************************************************
		"The Value of Urgency: Evidence from Congestion Pricing Experiments"
		Antonio M. Bento, Kevin Roth, Andrew R. Waxman
		Code: Andrew Waxman - awaxman@utexas.edu
		Last Updated: 4/06/24
*********************************************************************************************** 
cleancensus.do - makes ACS Census data
************************************************************************************************/
import delimted using .\data\raw\ACS_12_5YR_S1902_with_ann.csv,clear
drop in 1/2
keep v2 v4
ren v2 zip_code
ren v4 mean_inc
la var zip_code "Census ZIP Code Tabulation Area"

save ..\data\clean\censusdata, replace
